package club.orqlog.schedule.elasticjob.util;

public class SetupDb {

    public static void main(String[] args) {

        String insertSql = "insert into schedule_resume (name, sex, phone, address, education, state) values (?, ?, ?, ?, ?, ?)";
        for (int i = 0; i < 100; i++) {
            String sex = i % 2 == 0 ? "男" : "女";
            String education = "";
            switch (i % 3) {
                case 0:
                    education = "大专";
                    break;
                case 1:
                    education = "本科";
                    break;
                case 2:
                    education = "研究生";
                    break;
            }
            JdbcUtil.executeUpdate(insertSql, "王五"+i, sex, "13988766813", "上海海雾" + ((i % 5) + 1) + "路", education, "未归档");
        }
    }
}
